<?php

/**
 * Adds the table for mapping devices to slidestreams
 *
 */
class Db_018_bbce_add_device_slidestream_table extends Ot_Migrate_Migration_Abstract
{
    public function up($dba)
    {
        $query = "CREATE TABLE  `" . $this->tablePrefix . "tbl_slidestream_device` (
                    `deviceId` INT UNSIGNED NOT NULL ,
                    `slidestreamId` INT UNSIGNED NOT NULL ,
                    PRIMARY KEY (  `deviceId` ) ,
                    INDEX (  `slidestreamId` )
                    ) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;";
        
        $dba->query($query);
    }
    
    public function down($dba)
    {       
        $query = "";
        $dba->query($query);
    }
}